﻿CREATE PROCEDURE [dbo].[GetSettings]
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;

    -- Insert statements for procedure here
SELECT TOP 1 [CompanyName]
      ,[Address]
      ,[CompanyPhone]
      ,[MobilePhone]
      ,[Email]
      ,[Website]
      ,[Fblink]
      ,[Longitude]
      ,[Latitude]
      ,[Disclaimer]
      ,[AboutUs]
      ,[Module0]      
      ,[Module1]
      ,[Module2]
      ,[Module3]
      ,[Module4]
      ,[Module5]
      ,[Module6]
      ,[Module7]
      ,[Module8]
      ,[Module9]
      ,[Module10]
      ,[Module11]
      ,[Module12]
      ,[Module13]
      ,[Module14]
      ,[Module15]
      ,[Module16]
      ,[Module17]
      ,[Module18]
      ,[Module19]
      ,[Module20]
      ,[Module21]
      ,[Module22]
  FROM [Mobile_Settings]
  where [StatusDelete] = 0
END
